<?xml version="1.0" encoding="utf-8" ?> 

<sqlMap 
	namespace="Issue" 
  xmlns="http://ibatis.apache.org/mapping" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	>

	<!-- XML "behind" document for the People service class. -->

	<alias>
		<typeAlias alias="Issue" type="RaisingStudio.Data.Entities.Issue, RaisingStudio.Data.Entities" />
	</alias>
	
	<resultMaps>
		<resultMap id="Issue" class="Issue">
			<result property="IssueID" column="ISSUE_ID" />
			<result property="Title" column="ISSUE_TITLE" />
			<result property="Description" column="ISSUE_DESC" />
			<result property="Status" column="ISSUE_STS"  typeHandler="PerformanceTest.IssueStatusTypeHandler"/>
			<result property="IssueType" column="ISSUE_TYP"   typeHandler="PerformanceTest.IssueTypeTypeHandler"/>
			<result property="Owner" column="ISSUE_OWNR" />
			<result property="Progress" column="ISSUE_PRGS" />
			<result property="CreateTime" column="CREATE_TM" />
			<result property="Locked" column="ISSUE_LOCKED" />
		</resultMap>
	</resultMaps>
	
	<statements>
	
		<select id="SelectAllIssues"  parameterClass="int" resultMap="Issue">
      SELECT
      ISSUE_ID,
      ISSUE_TITLE,
      ISSUE_DESC,
      ISSUE_STS,
      ISSUE_TYP,
      ISSUE_OWNR,
      ISSUE_PRGS,
      CREATE_TM,
      ISSUE_LOCKED
      FROM DAC_ISSUE
    </select>
    
	</statements>
	
</sqlMap>
